package com.dwxt.community.dao;

import com.dwxt.community.aiequipment.aibin.entity.TrashCan;
import com.dwxt.community.aiequipment.aibin.entity.TrashCanExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface TrashCanMapper {
    int countByExample(TrashCanExample example);

    int deleteByExample(TrashCanExample example);

    int deleteByPrimaryKey(String deviceId);

    int insert(TrashCan record);

    int insertSelective(TrashCan record);

    List<TrashCan> selectByExample(TrashCanExample example);

    TrashCan selectByPrimaryKey(String deviceId);

    int updateByExampleSelective(@Param("record") TrashCan record, @Param("example") TrashCanExample example);

    int updateByExample(@Param("record") TrashCan record, @Param("example") TrashCanExample example);

    int updateByPrimaryKeySelective(TrashCan record);

    int updateByPrimaryKey(TrashCan record);


    List<TrashCan> selectAll(String id);

    List<TrashCan> get(TrashCan trashCan);

    List<TrashCan> getTrashCanForNotSupervisor();

    List<TrashCan> selectAllByXJY(String currentUserId);

    @Select("SELECT COUNT(*) FROM trash_can WHERE useing=0;")
    int selectUnusingEquipments();
}